select 'oracle' type_name,  (select instance_name from v$instance) dbms_name,  owner constraint_catalog,  owner constraint_schema,  constraint_name,  owner table_catalog,  owner table_schema,  table_name,  constraint_type,  nvl(deferrable,'NO') deferrable,  nvl(deferred,'NO') deferred  from dba_constraints a  where owner is not null  and constraint_type not in ('R','?')  and table_name not like 'BIN$%'
